
<!DOCTYPE html>

<html lang="en">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>练习题参考操作 &#8212; free-excel</title>
<script>
  document.documentElement.dataset.mode = localStorage.getItem("mode") || "";
  document.documentElement.dataset.theme = localStorage.getItem("theme") || "light"
</script>

  <!-- Loaded before other Sphinx assets -->
  <link href="_static/styles/theme.css?digest=92025949c220c2e29695" rel="stylesheet">
<link href="_static/styles/pydata-sphinx-theme.css?digest=92025949c220c2e29695" rel="stylesheet">


  <link rel="stylesheet"
    href="_static/vendor/fontawesome/5.13.0/css/all.min.css">
  <link rel="preload" as="font" type="font/woff2" crossorigin
    href="_static/vendor/fontawesome/5.13.0/webfonts/fa-solid-900.woff2">
  <link rel="preload" as="font" type="font/woff2" crossorigin
    href="_static/vendor/fontawesome/5.13.0/webfonts/fa-brands-400.woff2">

    <link rel="stylesheet" type="text/css" href="_static/pygments.css" />
    <link rel="stylesheet" type="text/css" href="_static/css/s4defs-roles.css" />

  <!-- Pre-loaded scripts that we'll load fully later -->
  <link rel="preload" as="script" href="_static/scripts/pydata-sphinx-theme.js?digest=92025949c220c2e29695">

    <script data-url_root="./" id="documentation_options" src="_static/documentation_options.js"></script>
    <script src="_static/jquery.js"></script>
    <script src="_static/underscore.js"></script>
    <script src="_static/_sphinx_javascript_frameworks_compat.js"></script>
    <script src="_static/doctools.js"></script>
    <script src="_static/sphinx_highlight.js"></script>
    <link rel="shortcut icon" href="_static/logo.ico"/>
    <link rel="index" title="Index" href="genindex.html" />
    <link rel="search" title="Search" href="search.html" />
    <link rel="prev" title="Datawhale" href="Datawhale.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
  </head>
  
  
  <body data-spy="scroll" data-target="#bd-toc-nav" data-offset="180" data-default-mode="">
    <div class="bd-header-announcement container-fluid" id="banner">
      

    </div>

    
    <nav class="bd-header navbar navbar-light navbar-expand-lg bg-light fixed-top bd-navbar" id="navbar-main"><div class="bd-header__inner container-xl">

  <div id="navbar-start">
    
    
  


<a class="navbar-brand logo" href="index.html">
  
  
  
  
    <img src="_static/logo.svg" class="logo__image only-light" alt="Logo image">
    <img src="_static/logo.svg" class="logo__image only-dark" alt="Logo image">
  
  
</a>
    
  </div>

  <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbar-collapsible" aria-controls="navbar-collapsible" aria-expanded="false" aria-label="Toggle navigation">
    <span class="fas fa-bars"></span>
  </button>

  
  <div id="navbar-collapsible" class="col-lg-9 collapse navbar-collapse">
    <div id="navbar-center" class="mr-auto">
      
      <div class="navbar-center-item">
        <ul id="navbar-main-elements" class="navbar-nav">
    <li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="%E4%B8%BB%E9%A1%B5.html">
  主页
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="Content/index.html">
  教程
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="%E4%BD%9C%E8%80%85.html">
  作者
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="Datawhale.html">
  Datawhale
 </a>
</li>

<li class="toctree-l1 current active nav-item">
 <a class="current reference internal nav-link" href="#">
  练习题参考操作
 </a>
</li>

    
</ul>
      </div>
      
    </div>

    <div id="navbar-end">
      
      <div class="navbar-end-item">
        <span id="theme-switch" class="btn btn-sm btn-outline-primary navbar-btn rounded-circle">
    <a class="theme-switch" data-mode="light"><i class="fas fa-sun"></i></a>
    <a class="theme-switch" data-mode="dark"><i class="far fa-moon"></i></a>
    <a class="theme-switch" data-mode="auto"><i class="fas fa-adjust"></i></a>
</span>
      </div>
      
      <div class="navbar-end-item">
        <ul id="navbar-icon-links" class="navbar-nav" aria-label="Icon Links">
        <li class="nav-item">
          <a class="nav-link" href="https://github.com/datawhalechina/free-excel" rel="noopener" target="_blank" title="GitHub"><span><i class="fab fa-github-square"></i></span>
            <label class="sr-only">GitHub</label></a>
        </li>
      </ul>
      </div>
      
    </div>
  </div>
</div>
    </nav>
    

    <div class="bd-container container-xl">
      <div class="bd-container__inner row">
          

<!-- Only show if we have sidebars configured, else just a small margin  -->
<div class="bd-sidebar-primary col-12 col-md-3 bd-sidebar">
  <div class="sidebar-start-items"><form class="bd-search d-flex align-items-center" action="search.html" method="get">
  <i class="icon fas fa-search"></i>
  <input type="search" class="form-control" name="q" id="search-input" placeholder="在这里搜索" aria-label="在这里搜索" autocomplete="off" >
</form><nav class="bd-links" id="bd-docs-nav" aria-label="Main navigation">
  <div class="bd-toc-item active">
    
  </div>
</nav>
  </div>
  <div class="sidebar-end-items">
  </div>
</div>


          


<div class="bd-sidebar-secondary d-none d-xl-block col-xl-2 bd-toc">
  
    
    <div class="toc-item">
      
<div class="tocsection onthispage mt-5 pt-1 pb-3">
    <i class="fas fa-list"></i> On this page
</div>

<nav id="bd-toc-nav">
    <ul class="visible nav section-nav flex-column">
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#">
   练习题参考操作
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id2">
   第一章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id3">
   第二章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id4">
   第三章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id5">
   第四章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id6">
   第五章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id7">
   第六章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id8">
   第七章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id9">
   第八章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id10">
   第九章
  </a>
 </li>
 <li class="toc-h1 nav-item toc-entry">
  <a class="reference internal nav-link" href="#id11">
   第十章
  </a>
 </li>
</ul>

</nav>
    </div>
    
    <div class="toc-item">
      
    </div>
    
  
</div>


          
          
          <div class="bd-content col-12 col-md-9 col-xl-7">
              
              <article class="bd-article" role="main">
                
  <div class="section" id="id1">
<h1>练习题参考操作<a class="headerlink" href="#id1" title="Permalink to this heading">#</a></h1>
</div>
<div class="section" id="id2">
<h1>第一章<a class="headerlink" href="#id2" title="Permalink to this heading">#</a></h1>
<p>1.1使用Excel数据导入功能，完成<code class="docutils literal notranslate"><span class="pre">data/chap1/Titanic_normal.csv</span></code>和<code class="docutils literal notranslate"><span class="pre">data/chap1/data/chap1/Titanic_special.txt</span></code>数据导入</p>
<div class="figure align-default">
<img alt="" src="_images/1.1.gif" />
</div>
<p>1.2完成<code class="docutils literal notranslate"><span class="pre">data/chap1/2.1.xlsx</span></code>中案例1-4中的问题</p>
<div class="figure align-default">
<img alt="" src="_images/1.2.gif" />
</div>
</div>
<div class="section" id="id3">
<h1>第二章<a class="headerlink" href="#id3" title="Permalink to this heading">#</a></h1>
<p>2.1.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.1.xlsx</span></code>工作簿中的【案例2】【案例3】的快捷键自动求和任务</p>
<div class="figure align-default">
<img alt="" src="_images/2.11.gif" />
</div>
<p>2.2.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.2.xlsx</span></code>工作簿中的【案例2】【案例3】的多行快速比对任务（提示：需要选中所有待比对表格框）</p>
<div class="figure align-default">
<img alt="" src="_images/2.21.gif" />
</div>
<p>2.3.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.3.xlsx</span></code>工作簿中的【案例2】【案例3】【案例4】的填充任务</p>
<div class="figure align-default">
<img alt="" src="_images/2.32.gif" />
</div>
</div>
<div class="section" id="id4">
<h1>第三章<a class="headerlink" href="#id4" title="Permalink to this heading">#</a></h1>
<p>3.1.选择<code class="docutils literal notranslate"><span class="pre">data/chap3/3.1.xlsx</span></code>工作簿中的【案例1】得到不同客户的消费次数</p>
<p>3.2.选择<code class="docutils literal notranslate"><span class="pre">data/chap3/3.1.xlsx</span></code>工作簿中的【案例2】得到不同客户的不同项目的消费次数</p>
<div class="figure align-default">
<img alt="" src="_images/3.11.gif" />
</div>
</div>
<div class="section" id="id5">
<h1>第四章<a class="headerlink" href="#id5" title="Permalink to this heading">#</a></h1>
<p>4.1.选择<code class="docutils literal notranslate"><span class="pre">data/chap4/4.1.xlsx</span></code>工作簿中的【案例1】，将客户原始得分为1以下的校正为0</p>
<p>4.2.选择<code class="docutils literal notranslate"><span class="pre">data/chap4/4.1.xlsx</span></code>工作簿中的【案例2】，客户1月2月中只要有1个月消费超过400，即为”高消费户”</p>
<p>4.3.选择<code class="docutils literal notranslate"><span class="pre">data/chap4/4.1.xlsx</span></code>工作簿中的【案例3】，能否不使用IFS函数，使用IF函数通过嵌套完成相应的务。</p>
<div class="figure align-default">
<img alt="" src="_images/4.11.gif" />
</div>
<p>4.4.打开<code class="docutils literal notranslate"><span class="pre">data/chap4/4.2xlsx</span></code>中的【案例1】语文成绩在80分以上的同学成绩之和</p>
<p>4.5.打开<code class="docutils literal notranslate"><span class="pre">data/chap4/4.2xlsx</span></code>中的【案例2】统计所有苹果系列产品的销售额</p>
<p>4.6.打开<code class="docutils literal notranslate"><span class="pre">data/chap4/4.2xlsx</span></code>中的【案例6】完成所有手机的销售额求和</p>
<div class="figure align-default">
<img alt="" src="_images/4.21.gif" />
</div>
</div>
<div class="section" id="id6">
<h1>第五章<a class="headerlink" href="#id6" title="Permalink to this heading">#</a></h1>
<p>5.1.完成<code class="docutils literal notranslate"><span class="pre">data/chap5/5.1.xlsx</span></code>工作簿中的【案例1-3】</p>
<p>参考教程</p>
<p>5.2.完成<code class="docutils literal notranslate"><span class="pre">data/chap5/5.2.xlsx</span></code>工作簿中的【案例1】中身份证后6位加密</p>
<div class="figure align-default">
<img alt="" src="_images/5.21.gif" />
</div>
</div>
<div class="section" id="id7">
<h1>第六章<a class="headerlink" href="#id7" title="Permalink to this heading">#</a></h1>
<p>6.1.选择VLOOKUP和XLOOKUP这2种函数中的一种，完成<code class="docutils literal notranslate"><span class="pre">data/chap6/6.1xlsx</span></code>中的【案例1-4】</p>
<p>参考教程</p>
</div>
<div class="section" id="id8">
<h1>第七章<a class="headerlink" href="#id8" title="Permalink to this heading">#</a></h1>
<p>7.1.打开<code class="docutils literal notranslate"><span class="pre">data/chap7/7.1xlsx</span></code>中的【案例1】计算河北区中商品1的最小销售额</p>
<div class="figure align-default">
<img alt="" src="_images/7.11.gif" />
</div>
<p>7.2.打开<code class="docutils literal notranslate"><span class="pre">data/chap7/7.1xlsx</span></code>中的【案例1】计算湖北中什么渠道下的什么商品具有最高销售额</p>
<div class="figure align-default">
<img alt="" src="_images/7.21.gif" />
</div>
</div>
<div class="section" id="id9">
<h1>第八章<a class="headerlink" href="#id9" title="Permalink to this heading">#</a></h1>
<p>8.1.选择<code class="docutils literal notranslate"><span class="pre">data/chap8/8.2.xlsx</span></code>工作簿中的【案例1】，对拜访客户数大于5以上的业务员进行黄色填充</p>
<div class="figure align-default">
<img alt="" src="_images/8.11.gif" />
</div>
</div>
<div class="section" id="id10">
<h1>第九章<a class="headerlink" href="#id10" title="Permalink to this heading">#</a></h1>
<p>9.1.选择<code class="docutils literal notranslate"><span class="pre">data/chap9/9.1.xlsx</span></code>工作簿中的【数据源】绘制不同的透视图</p>
<div class="figure align-default">
<img alt="" src="_images/9.11.gif" />
</div>
</div>
<div class="section" id="id11">
<h1>第十章<a class="headerlink" href="#id11" title="Permalink to this heading">#</a></h1>
<p>10.1.完成数据看板，需要通过按钮调节周数，同时销售额，订单数以及数据图进行变化</p>
<p>参考教程</p>
</div>


              </article>
              

              
          </div>
          
      </div>
    </div>

  
  
  <!-- Scripts loaded after <body> so the DOM is not blocked -->
  <script src="_static/scripts/pydata-sphinx-theme.js?digest=92025949c220c2e29695"></script>

<footer class="bd-footer"><div class="bd-footer__inner container">
  
  <div class="footer-item">
    <p class="copyright">
    &copy; Copyright 2022, Datawhale, 牧小熊.<br>
</p>
  </div>
  
  <div class="footer-item">
    <p class="sphinx-version">
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 5.3.0.<br>
</p>
  </div>
  
</div>
</footer>
  </body>
</html>